Model Table ACCOUNTING PERIOD

This model dimension represents the accounting periods in Fiancials is based on the IFS Cloud dimension DIM_ACCOUNTING_PERIOD. All models that refer to this dimension will have the attributes and hierarchies as described below.

Natural parent is company, i.e. each company has its on set of accounting periods.

Attributes

Attribute Description (where applicable)
Acc Period End DateRepresents the end date (END_DATE) of an accounting period
Acc Period Start DateRepresents the start date (START_DATE) of an accounting  period
Accounting PeriodRepresents the CODE of the dimension, i.e. 'YYYYPP' where YYYY is the accounting year and PP is the accounting period.
Accounting Period DescRepresents the DESCRIPTION of an accounting period.
Accounting Period NoRepresents the period part, i.e. ACCOUNTING_PERIOD
Accounting Period TypeRepresents the description of the period type (PERIOD_TYPE_DESC)
Accounting YearRepresents the year part, i.e. ACCOUNTING_YEAR
Accounting Year PeriodRepresents the CODE of the dimension, i.e. i.e. 'YYYYPP' where YYYY is the accounting year and PP is the accounting period.
CompanyRepresents the natural parent COMPANY

Hierarchies

Hierarchy Level
AccountingYear-PeriodHy
Company
Accounting Year
Accounting Period
AccountingYearHy
Company
Accounting Year
AccountingYearPeriodHy
Company
Accounting Year Period

USED BY MODEL(S)

Model Name
Sales

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ACCOUNTING PERIODDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIODOn Line